USE [DeltaFlex]
GO
IF ( OBJECT_ID('dbo.sp_InsertarMaquinaCartoner') IS NOT NULL ) 
   DROP PROCEDURE dbo.sp_InsertarMaquinaCartoner
GO

CREATE PROCEDURE dbo.sp_InsertarMaquinaCartoner
    @IDCLIENTIMPRESOR int,
	@NOMMAQUINA nvarchar(50),
	@DEFLACCIOMAQUINA nvarchar(100),
	@CALIBREMAQUINA nvarchar(10),
	@URLFITXAMAQUINA nvarchar(100)
       
AS 
BEGIN 
     SET NOCOUNT ON 

	 DECLARE @IDMAQUINACARTONER int = NEXT VALUE FOR SEQ_MAQUINACARTONER;

     INSERT INTO MAQUINA_CARTONER (IDMAQUINACARTONER, IDCLIENTIMPRESOR,NOMMAQUINA,DEFLACCIOMAQUINA,CALIBREMAQUINA,URLFITXAMAQUINA)
							VALUES(@IDMAQUINACARTONER,@IDCLIENTIMPRESOR,@NOMMAQUINA,@DEFLACCIOMAQUINA,@CALIBREMAQUINA,@URLFITXAMAQUINA)

	END	
GO		